AdStudentTransferHeader 
Logical Entity Name  AdStudentTransferHeader 
Default Table Name  AdStudentTransferHeader 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

AdStudentTransferHeader Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SyStudentID(FK)    int  NO 
 
FromAdEnrollID(FK)    int  NO 
 
ToAdEnrollID(FK)    int  YES 
 
FromSyCampusID(FK)    int  NO 
 
ToSyCampusID(FK)    int  NO 
 
FromAdProgramVersionID(FK)    int  NO 
 
ToAdProgramVersionID(FK)    int  NO 
 
MoveDateBilled    bit  NO 
 
MoveStartDate    bit  NO 
 
MoveLDA    bit  NO 
 
MoveCourses    char(1)  NO 
 
PerformDocReview    bit  NO 
 
FaCmTemplateID(FK)    int  YES 
 
FaSyStaffID(FK)    int  YES 
 
SaCmTemplateID(FK)    int  YES 
 
SaSyStaffID(FK)    int  YES 
 
SyGroupsID    int  YES 
 
ProcessDate    datetime  NO 
 
ProcessThis    bit  NO 
 
Processed    bit  NO 
 
Reversed    bit  NO 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
Ts    timestamp  NO 
 
ModifyFees    bit  NO 
 
AdStudentTransferHeaderID(PK)    int  NO 
 
MoveFA    bit  NO 
 
MoveBudget    bit  NO 
 

AdStudentTransferHeader Primary and Unique Keys 
Key Name  Key Type  Keys 
AdStudentTransferHeader_AdStudentTransferHeaderID_U_C_IDX  PrimaryKey  AdStudentTransferHeaderID 

AdStudentTransferHeader Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
CmTemplate  Non-Identifying  Zero or One to Zero or More  FK_AdStudentTransferHeader_FaCmTemplateID_CmTemplate_CmTemplateID      FaCmTemplateID  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_AdStudentTransferHeader_FaSyStaffID_SyStaff_SyStaffID      FaSyStaffID  NO  YES 
AdEnroll  Non-Identifying  One To Zero or More  FK_AdStudentTransferHeader_FromAdEnrollID_AdEnroll_AdEnrollID      FromAdEnrollID  NO  YES 
AdProgramVersion  Non-Identifying  One To Zero or More  FK_AdStudentTransferHeader_FromAdProgramVersionID_AdProgramVersion_AdProgramVersionID      FromAdProgramVersionID  NO  YES 
SyCampus  Non-Identifying  One To Zero or More  FK_AdStudentTransferHeader_FromSyCampusID_SyCampus_SyCampusID      FromSyCampusID  NO  YES 
CmTemplate  Non-Identifying  Zero or One to Zero or More  FK_AdStudentTransferHeader_SaCmTemplateID_CmTemplate_CmTemplateID      SaCmTemplateID  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_AdStudentTransferHeader_SaSyStaffID_SyStaff_SyStaffID      SaSyStaffID  NO  YES 
syStudent  Non-Identifying  One To Zero or More  FK_AdStudentTransferHeader_SyStudentID_syStudent_SyStudentID      SyStudentID  NO  YES 
AdEnroll  Non-Identifying  Zero or One to Zero or More  FK_AdStudentTransferHeader_ToAdEnrollID_AdEnroll_AdEnrollID      ToAdEnrollID  NO  YES 
AdProgramVersion  Non-Identifying  One To Zero or More  FK_AdStudentTransferHeader_ToAdProgramVersionID_AdProgramVersion_AdProgramVersionID      ToAdProgramVersionID  NO  YES 
SyCampus  Non-Identifying  One To Zero or More  FK_AdStudentTransferHeader_ToSyCampusID_SyCampus_SyCampusID      ToSyCampusID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_AdStudentTransferHeader_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdStudentTransferCourses  Identifying  One To Zero or More  FK_AdStudentTransferCourses_AdStudentTransferHeaderID_AdStudentTransferHeader_AdStudentTransferHeaderID        NO  YES 
AdStudentTransferDocuments  Identifying  One To Zero or More  FK_AdStudentTransferDocuments_AdStudentTransferHeaderID_AdStudentTransferHeader_AdStudentTransferHeaderID        NO  YES 

AdStudentTransferHeader Check Constraints 
Check Constraint Name  CheckConstraint 

AdStudentTransferHeader Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

AdStudentTransferHeader Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentEnrollmentPeriodTransfer 
NO       
Physical (Microsoft SQL Server)
dbo.AdStudentTransferHeader 
NO       

AdStudentTransferHeader Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  StudentEnrollment 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 

AdStudentTransferHeader Data Movement Rules 
Name  Type  Rule Text/Value